5-E
Simple site for the info you need...
$r1c1 = "This is row1 column1" $r1c2 = "This is row1 column2" $r2c1 = "This is row2 column1" $r2c2 = "This is row2 column2" #create Excel Workbook $Excel = New-Object -Com Excel.Application $Excel.visible = $True $Excel = $Excel.Workbooks.Add() $wSheet = $Excel.Worksheets.Item(1) $wSheet.Cells.item(1,1) = "Column1:" $wSheet.Cells.Item(1,2) = "Column2:" $WorkBook = $wSheet.UsedRange $WorkBook.Interior.ColorIndex = 45 $WorkBook.Font.ColorIndex = 1 $WorkBook.Font.Bold = $True $intRow = 1 $intRow++ $wSheet.Cells.item($intRow,1) = $r1c1 $wSheet.Cells.Item($intRow,2) = $r1c2 $intRow++ $wSheet.Cells.item($intRow,1) = $r2c1 $wSheet.Cells.Item($intRow,2) = $r2c2